﻿<?php if (!defined('SERVER_ROOT')) exit('No direct script access allowed');

class canbo_Model extends Model {

    function __construct()
    {
        parent::__construct();
    }
    public function TRA_CUU_CAN_BO($arr_filter){
        $v_MA_SO_CAN_BO= $arr_filter['txt_MA_SO_CAN_BO'];
        $v_TEN_CAN_BO= $arr_filter['txt_TEN_CAN_BO'];
        $v_CMND= $arr_filter['txt_CMND'];
        $v_GIOI_TINH= $arr_filter['cbx_GIOI_TINH'];
        $v_DC_THUONG_TRU= $arr_filter['txt_DC_THUONG_TRU'];
        $v_DC_LIEN_LAC= $arr_filter['txt_DC_LIEN_LAC'];
        $v_DT_CO_DINH= $arr_filter['txt_DT_CO_DINH'];
        $v_DT_DI_DONG= $arr_filter['txt_DT_DI_DONG'];
        $v_MA_DAN_TOC= $arr_filter['cbx_MA_DAN_TOC'];
        $v_MA_TON_GIAO= $arr_filter['cbx_MA_TON_GIAO'];
        $v_MA_HOC_HAM= $arr_filter['cbx_MA_HOC_HAM'];
        $v_MA_HOC_VI= $arr_filter['cbx_MA_HOC_VI'];
        $v_NGAY_VAO_DOAN= $arr_filter['txt_NGAY_VAO_DOAN'];
        $v_NGAY_VAO_DANG= $arr_filter['txt_NGAY_VAO_DANG'];
        $v_NGAY_KY_HD= $arr_filter['txt_NGAY_KY_HD'];
        $v_NGAY_KET_THUC_HD= $arr_filter['txt_NGAY_KET_THUC_HD'];
        return $this->db->ExecuteCursor("BEGIN TRACUU.TRA_CUU_CAN_BO
                                                      (:CUR,
                                                      '$v_MA_SO_CAN_BO',
                                                      '$v_TEN_CAN_BO',
                                                      '$v_CMND',
                                                       $v_GIOI_TINH ,
                                                      '$v_DC_THUONG_TRU',
                                                      '$v_DC_LIEN_LAC',
                                                      '$v_DT_CO_DINH',
                                                      '$v_DT_DI_DONG',
                                                      '$v_MA_DAN_TOC',
                                                      '$v_MA_TON_GIAO',
                                                      '$v_MA_HOC_HAM',
                                                      '$v_MA_HOC_VI',
                                                      '$v_NGAY_VAO_DOAN',
                                                      '$v_NGAY_VAO_DANG',
                                                      '$v_NGAY_KY_HD',
                                                      '$v_NGAY_KET_THUC_HD'
                                                      );END;",'CUR');
    }
}